--
-- NB!
-- Replace schema_name to your schema's name
--

GRANT SELECT_CATALOG_ROLE TO avassiljev;
GRANT EXECUTE_CATALOG_ROLE TO avassiljev;

GRANT CREATE TABLE TO avassiljev;
GRANT CREATE TRIGGER TO avassiljev;
GRANT CREATE VIEW TO avassiljev;
GRANT CREATE PROCEDURE TO avassiljev;
GRANT CREATE JOB TO avassiljev;
GRANT CREATE SEQUENCE TO avassiljev;
GRANT CREATE SYNONYM TO avassiljev;

GRANT EXECUTE ON DBMS_CDC_PUBLISH TO avassiljev;
GRANT EXECUTE ON SYS.DBMS_CDC_SUBSCRIBE TO avassiljev;
GRANT EXECUTE ON dbms_lock TO avassiljev;

GRANT UNLIMITED TABLESPACE TO avassiljev;

GRANT DBA TO avassiljev;

GRANT SELECT ON SYS.CDC_CHANGE_TABLES$ TO avassiljev;
GRANT SELECT ON CHANGE_TABLES TO avassiljev;
GRANT SELECT ON all_subscriptions TO avassiljev;
GRANT SELECT ON dba_jobs_running TO avassiljev;
GRANT SELECT ON v_$session TO avassiljev;


BEGIN
	SYS.DBMS_CDC_PUBLISH.CREATE_CHANGE_SET('SYNC_SET_CVIEW', 'Change set for cdcviews', 'SYNC_SOURCE', 'N');
END;
/


EXIT
